A Spreadsheet Scenario Analysis Technique That Integrates with Optimization and Simulation
نویسندگان
چکیده
منابع مشابه
A Spreadsheet Scenario Analysis Technique That Integrates with Optimization and Simulation
S analysis is a widely used technique, and business students should be proficient in running scenarios through a spreadsheet model. We propose 10 desirable properties for a scenario analysis technique, and show that the Microsoft Excel Scenario Manager tool satisfies only one of them. We provide a tutorial for a better technique that can be programmed into an existing spreadsheet in a matter of...
متن کاملA Distributed Disaster Simulation System That Integrates Sub-simulators
Integrated simulation systems are important tools to decrease the damage caused by various disasters. In peacetime, it would be used for disaster-proof city planning, disaster prevention plans, and disaster response training. At the time of a disaster occurs, it will be used for real-time simulation to predict disasters. The paper describes the simulation system that has the following features:...
متن کاملSupply Chain Analysis : Spreadsheet or Simulation ?
In the last few decades, a lot of company effort has been spent in the optimization of internal efficiency, aiming at cost reduction and competitiveness. Especially over the last decade, there has been a consensus that not only the company, but the whole supply chain in which it fits, is responsible for the success or failure of any business. Therefore, supply chain analysis tools and methodolo...
متن کاملGenerating scenario trees: A parallel integrated simulation-optimization approach
A crucial issue for addressing decision-making problems under uncertainty is the approximate representation of multivariate stochastic processes in the form of scenario tree. This paper proposes a scenario generation approach based on the idea of integrating simulation and optimization techniques. In particular, simulation is used to generate outcomes associated with the nodes of the scenario t...
متن کاملStop that Subversive Spreadsheet!
This paper documents the formation of the European Spreadsheet Risks Interest Group (EuSpRIG www.eusprig.org) and outlines some of the research undertaken and reported upon by interested parties in EuSpRIG publications.
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: INFORMS Transactions on Education
سال: 2009
ISSN: 1532-0545,1532-0545
DOI: 10.1287/ited.1090.0027